SQL articles.
Last changed: 01 January 2024
How to check if the secondary node in SQL is readable?
Two ways how to check wether the secondary node is readable.
1. the GUI in the Availability Group Properties
2. SQL code, management view
1. Availability Group Properties
2. SQL code, management view
SELECT * FROM sys.availability_replicas
Two columns could be checked:
- secondary_role_allow_connections
- and secondary_role_allow_connections_desc
If it is not readable then secondary_role_allow_connections = 0 and secondary_role_allow_connections_desc = NO.
Back to articles Previous = How to get the free disk space of a remote SQL server?
